Home & Job Distribution

In this part, we used ACS and LODES data to explore the changing trend of home and job distribution between pre-COVID(2019) and post-COVID(2021). We used LODES data to identify the job related features, such as employment number, labor force age, income and industry. We aggregate the workplace and homeplace of the original LODES data (JT01, primary job) from census block to census tract level. And convert the population of different categories (Age, Income, Industry) into proportion percent. And we used ACS data to explore the demographic features, such as population density, housing price and tenure.

Code
# Load NYC Metro Data
metro_geojson_path = 'Data/Geo/metro.geojson'
metro_gdf = gpd.read_file(metro_geojson_path).to_crs(epsg=2263)

# Load LODES data
csv_path = 'Data/LODES/'

# Read csv file
w_21 = pd.read_csv(csv_path + 'OD_w_2021.csv')
w_19 = pd.read_csv(csv_path + 'OD_w_2019.csv')
h_21 = pd.read_csv(csv_path + 'OD_h_2021.csv')
h_19 = pd.read_csv(csv_path + 'OD_h_2019.csv')

1. Employment Number

To explore the employment trend in recent 20 years, we used API for Bureau of Labor Statistics to see the total number of jobs in NYC Metro Region. It shows very clearly that the number of jobs has dropped significantly in 2008 (predicted to be an economic crisis) and 2019 (pendamic). However, from 2021 onwards, there are signs of economic recovery.


Geographically, from 2019 to 2022, all counties in NYC metro region suffer a decrease in work position. The entire region loses 513,813 jobs. 65.6% job decrease is in Manhatten, the economic core of the region.

The employment number is calculated by the total job number in each census tract from LODES dataset. As the map below shows, the overall employment number distribution is roughly the same before and after the pandemic. Considering the size of census tract, employment is concentrated at Midtown and Downtown Manhattan and downtown Brooklyn.

Code
map_w_19 + map_w_21

2. Middle-age Labor Force Age

Here, we calculated the middle-age labor force (age 30-54) percentage to explore the labor force age structure. We guess that the younger employees have higher will to commute longer distance for work, which might be an importance variable to predict the commute distance.

For both year 2019 and 2021, the middle-age labor force tend to work within the city, while the suburbs, such as Long Island and Staten Island have a lower percentage of middle-age labor force. We also found that, compared to pre-COVID time, there is a higher proportion of middle-age work force in suburban areas. It might be a result of the emerging WFH working pattern and lower housing price of suburbs.

Code
map_w_19_age + map_w_21_age

3. Income

In these two maps, we try to compare the low income ($1,250/month or less) jobs proportion. For both year 2019 and 2021, New York City, especially Manhattan, provides more high-paying jobs than suburbs like Long Island, Staten Island and Jersey City. From 2019 to 2021, there are more low-paying jobs across the metro area, especially for the surrouding area.

Code
map_w_19_low_income + map_w_21_low_income

4. Service Industry

LODES dataset classifies the industries into (1) Goods Producing; (2) Trade, Transportation, and Utilities; and (3) All Other Services. Among them, service industry is mainly concentrated at the city. But south Bronx, north Brooklyn and south Queens are in low proportion of service industry.

Code
map_w_19_service + map_w_21_service

5. Population Density

In this step, we use ACSDT5Y2021ACS and ACSDT5Y2019 data to explore the jobs change in NYC metro region. From 2019 to 2022, the total population in NYC metro region increases 342,629. Looking at population density maps, the rapid population growth areas are Brooklyn, Queens and Staten Island.

6. Home Distribution

More people are moving to the cheaper suburban area.

Code
map_h_19 + map_h_21

7. Median Housing Value

From 2019 to 2021, the housing prices rise across the entire NYC metro region, especially in Staten Island, Queens, Long Island and Brooklyn.

However, looking at the housing prices change rate, South Long Island, Brooklyne, Jersey City, Queens increase the most.

8. Tenure

The closer the settlement is situated to the NYC metro region boundaries, the higher the proportion of owner-occupied housing is, which is somewhat related to the relatively low house values.

Make this Notebook Trusted to load map: File -> Trust Notebook

Make this Notebook Trusted to load map: File -> Trust Notebook